package com.jhg.drgclinicalpathway.dao.sys;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.jhg.drgclinicalpathway.domain.SysOps;
import com.jhg.drgclinicalpathway.domain.sys.AccountInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface SysOpsDao extends BaseMapper<SysOps> {

    @Select({
            "select name from sys_ops",
            "where ctime between #{stime} and #{etime}",
            "group by name"
    })
    public List<String> findNameByTime(@Param("stime") String stime,
                                       @Param("etime") String etime);
}
